CREATE EXTERNAL TABLE jms_dm.dm_dev_center_operate_waybill_detail_dt
(
    type                   int COMMENT '类型1出港2同城3中转4进港',
    waybill_no             string COMMENT '运单号',
    network_code           string COMMENT '到件站点code',
    network_name           string COMMENT '到件站点name',
    network_type           string COMMENT '到件站点类型',
    number                 string COMMENT '到件站点序列号',
    send_packagecode       string COMMENT '到件站点发件扫描包号',
    arrival_packagecode    string COMMENT '到件站点到件扫描包号',
    next_network_code      string COMMENT '到件站点下一站code',
    next_network_name      string COMMENT '到件站点下一站name',
    next_network_type      string COMMENT '到件站点下一站类型',
    source_arrival         string COMMENT '到件站点到件来源',
    arrival_time           string COMMENT '到件站点到件时间',
    send_time              string COMMENT '到件站点发件时间',
    send_build_bag_time    string COMMENT '到件站点建包时间',
    send_build_bag         string COMMENT '到件站点建包包号',
    before_network_code    string COMMENT '到件站点上一站code',
    before_network_name    string COMMENT '到件站点上一站name',
    before_network_type    string COMMENT '到件站点上一站站点类型',
    same_city_port_type    int COMMENT '同城归属1进港2出港',
    transfer_port_type     int COMMENT '中转归属1进港2出港',
    send_pack_later_time   string COMMENT '到件站点包对应发件时间',
    send_pack_falg         int COMMENT '1代表24小时内没有进行包发件0否',
    date_time              string COMMENT '日期',
    agent_code             string COMMENT '代理区code',
    agent_name             string COMMENT '代理区name',
    plan_next_network_code string COMMENT '规划下一站',
    plan_next_network_type string COMMENT '规划下一站类型',
    unbagging_packagecode  string COMMENT '卸车包号'
)
    COMMENT '中转件量分析明细'
    PARTITIONED BY (
        dt string COMMENT 't-2')
    STORED AS parquet
    LOCATION
        '/dw/hive/jms_dm.db/external/dm_dev_center_operate_waybill_detail_dt' 